The MediaFACE 4.0 application realizes interaction with different databases via an ODBC mechanism. It allows data import from external sources (Oracle, MS SQL, MS Access databases). It is possible to set-up different Data Sources in List Manager using existing DSNs and to create new ones. Data that appears as a result of interaction with a database corresponds to query conditions that have been set at the Data Source creation stage. Use commas for separating files.
The Data Source wizard is launched from the Lists Manager dialog with one of the source nodes selected.
Example of the Lists Manager dialog for Data Sources
To import data from an external source:
1. In the Lists Manager dialog click the New button. The application displays the Data Source wizard (screen 1), which allows you to define a connection string. You are allowed to enter this string directly (if you are an experienced user) or with the help standard ODBC mechanism by clicking Select.
Example of the Data Source wizard (screen 1)
2. When you fill in a connection string with corresponding information click Next. The application displays the Data Source wizard (screen 2) as shown in the example below. Here you have to choose a table from the Table combo box and select columns for your query from the Available columns list.
Example of the Data Source wizard (screen 2)
3. Click Next. The application displays the Data Source wizard (screen 3) as shown in the example below. This screen fully explains how to filter data if any.
Example of the Data Source wizard (screen 3)
4. Click Next. The application displays the Data Source wizard (screen 4) as shown in the example below. This screen specifies information sorting preferences, if any.
Example of the Data Source wizard (screen 4)
5. Click Next. The application displays the Data Source wizard (screen 5) as shown in the example below. On this step the application prepares all the information required for generating the Data Source. If you want to check how the application prepared data click Test. You can view data prepared by the wizard.
Example of the Data Source wizard (screen 5)
6. Click Finish to complete the operation. If the data source was finished successfully, the data source list in the Lists Manager dialog will contain all fields, which are extracted from the data source.